Setting Foreign Key Properties

Use the Name edit box to enter a name for the new key and then select a table field to include in the key from the Field(s) Name group.

Use the Reference Schema and Reference Table dropdown lists to select a foreign schema and table respectively.

To include field(s) to the key, just simply click the Field(s) Name/Foreign Field(s) Name field or click to open the editor(s) for editing.

The On Delete and On Update dropdown list define the type of the actions to be taken.

CASCADE
Delete any rows referencing the deleted row, or update the value of the referencing column to the new value of the referenced column, respectively.

SET NULL
Set the referencing column(s) to null.

NO ACTION
Produce an error indicating that the deletion or update would create a foreign key constraint violation. If the constraint is deferred, this error will be produced at constraint check time if there still exist any referencing rows. This is the default action.

RESTRICT
Produce an error indicating that the deletion or update would create a foreign key constraint violation. This is the same as NO ACTION except that the check is not deferrable.